if object_id('BIMonitor.WMIQueries') is not null
  drop table BIMonitor.WMIQueries
go

create table BIMonitor.WMIQueries
 (Environment              varchar(75) not null,
  WMITask                  varchar(75) not null,
  WMIConnectionString      varchar(150) not null,
  ComponentType            varchar(25),
  ServerName               varchar(75) not null,
  WQL                      varchar(250) not null,

  constraint pk_WMIQueries primary key(Environment,WMITask));